
<!DOCTYPE html>
<html>
<script th:inline="javascript"> var ctx = [[@{/}]] ; </script> <head th:include="include :: header_LayUi"></head>

<style type="text/css">
    table.gridtable {
        font-family: verdana,arial,sans-serif;
        font-size: 11px;
        color: #333333;
        border-width: 1px;
        border-color: #666666;
        border-collapse: collapse;
    }

        table.gridtable th {
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #666666;
            background-color: #dedede;
        }

        table.gridtable td {
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #666666;
            background-color: #ffffff;
        }




    table.hovertable {
        font-family: verdana,arial,sans-serif;
        font-size: 11px;
        color: #333333;
        border-width: 1px;
        border-color: #999999;
        border-collapse: collapse;
    }

        table.hovertable th {
            background-color: #c3dde0;
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #a9c6c9;
        }

        table.hovertable tr {
            background-color: #d4e3e5;
        }

        table.hovertable td {
            border-width: 1px;
            padding: 8px;
            border-style: solid;
            border-color: #a9c6c9;
        }
</style>

<body layadmin-themealias="default">

    <div style="margin-top: 10px; margin-left: 10px; margin-right: 10px;">
    <table width="100%" class="gridtable">
        
        <tr>
            <td style="color:red;width:100px;text-align:right"> * 报表名称：</td>
            <td colspan="2">
                <input id="SNAME" type="text" class="form-control" />
            </td>
            <td style="width:100px;"><input   type="checkbox" checked />&nbsp;开发者模式</td>
        </tr>

        <tr>
            <td style="width:100px;text-align:center">
                核心算法语句
            </td>
            <td>
                <textarea id="COMPUTER_TSQL" rows="6" style="width:100%"></textarea>
            </td>
            <td style="width:100px;text-align:center">
                <input type="button" value="保存" style="width:80px;height:100px;" onclick="fun_addModel()" />
            </td>
            <td style="width:100px;text-align:center">
                <input type="button" value="预览" style="width:80px;height:100px;" onclick="ExecutClick()" />
            </td>
        </tr>

        <tr>
            <td class="formTitle">报表算法<br />SQL语句参数<br />替换列表</td>
            <td class="formValue" colspan="3">
                <textarea id="SQL_PARAMS" class="form-control" rows="2" placeholder="# 分割，多条记录请换行；# 后的【开始/结束】时间，请分别用【 $START_TIME$ ， $END_TIME$ 】代替"></textarea>
                <span style="color:blue;">
                    示例：TO_CHAR(SYSDATE,'YYYY')#TO_CHAR(TO_DATE('$START_TIME$','YYYY-MM-DD'),'yyyy')<br />
                    注意：【被替换字符串】与【替换字符串】用 # 分割，# 前为要被替换的字符串；多条记录请换行；# 后的【开始/结束】时间，请分别用【 $START_TIME$ ， $END_TIME$ 】占位符代替
                </span>
            </td>
        </tr>
        <tr>
            <td colspan="4">
                <div id="div_report" style="overflow:scroll;" />
            </td>
        </tr>

        <tr>
            <td style=" width:100px;text-align:right">   报表说明：</td>
            <td colspan="3">
                <input id="REPORT_DESCRIPTION" type="text" class="form-control" />
            </td>
        </tr>

    </table>
</div>
    

	<div th:include="include :: footer_LayUi"></div>
	<script type="text/javascript" src="/static/itemjs/system/commonreportstatistics/addModel.js" th:src="@{/itemjs/system/commonreportstatistics/addModel.js}"></script>

    <style id="LAY_layadmin_theme">
        .layui-side-menu, .layadmin-pagetabs .layui-tab-title li:after, .layadmin-pagetabs .layui-tab-title li.layui-this:after, .layui-layer-admin .layui-layer-title, .layadmin-side-shrink .layui-side-menu .layui-nav > .layui-nav-item > .layui-nav-child { background-color: #20222A !important; }
        .layui-nav-tree .layui-this, .layui-nav-tree .layui-this > a, .layui-nav-tree .layui-nav-child dd.layui-this, .layui-nav-tree .layui-nav-child dd.layui-this a { background-color: #009688 !important; }
        .layui-layout-admin .layui-logo { background-color: #20222A !important; }
    </style>
</body>

</html>